SUM Function

The SUM function in Excel is one of the most commonly used functions for mathematical calculations. It allows users to easily add together a series of numbers, whether they are individual values, cell references, or ranges of cells. Here’s a detailed look at the SUM function, including its syntax, usage, and examples.

Basic Syntax

=SUM(number1, [number2], ...)

Here, number1, number2, etc., are numbers or ranges of cells you want to sum.

Examples

• =SUM(A1:A10) — Sums all values in the range from A1 to A10.
• =SUM(A1, B1, C1) — Adds the values in A1, B1, and C1.

SUMIF and SUMIFS Functions

The SUMIF and SUMIFS functions are variations that allow you to sum only the cells that meet specific conditions.

SUMIF Syntax

=SUMIF(range, criteria, [sum_range])

range: The range of cells to evaluate against the criteria.

criteria: The condition that determines which cells to sum.

sum_range: (Optional) The cells to sum if different from the range.

Example

=SUMIF(A2:A10, ">100", B2:B10) — Sums the values in B2:B10 where the corresponding value in A2:A10 is greater than 100.

SUMIFS Syntax

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

The SUMIFS function lets you apply multiple criteria to determine which cells to sum.

Example

=SUMIFS(C2:C10, A2:A10, "Region1", B2:B10, ">100") — Sums values in C2:C10 where A2:A10 equals "Region1" and B2:B10 is greater than 100.